UBB.Developers Forums UBB.threads 6 V6 Modifications Forum Design Integration Help with PhotoPost Pro!!!

Hi Gang,

I am getting like one response a day over on the PP support site, and this is just ridiculous... I bought PPPro, after seeing and hearing many great things about it, including how simple it was to install...

Well, we bought it 5 days ago, and after 2 failed installs, 2 complete removals of all files and DB tables, I am finally able to access the admin page and finish the setup.

What I cannot do is upload photos. Everything I have tried fails with DB errors. My mogrify path is correct, so the host says, everything else seems to be in order but I keep getting:

Database error! Please report to System Administrator.

INSERT INTO photos (id,user,userid,cat,date,title,description,keyword
s,bigimage,width,height,filesize,medwidth,medheigh
t,medsize,approved,lastpost,watermarked,allowprint
,extra1,extra2,extra3,extra4,extra5,extra6) values(NULL,'Raconteur', 79, 509, 1048191297, 'barbouriLg', '', '', 'barbouriLg.jpg', 640, 480, 97407, , , , 1, 1048191297, 'no','','','','','','','')


I had another user try to upload a photo and she got:

Error creating resized medium image! Error code: 1 Command attempted: /usr/bin/mogrify -format JPG -geometry 320x320 /s101/home4/syngnathids/ubbthreads/PP/data/509/4MVC-008F-med.JPG

After checking with the domain host about the veracity of the location of mogrify, they say that according to their documentation the format param should be "JPEG" not "JPG"... I cannot imagine that being the problem as it would appear everyone else would see the same issue. Although, there are several posts over at PP regarding the database error...

Now, I am left in the lurch... I am trying to get this thing running so my staff can populate the photo galleries before my energy completely runs out, and working at a one message a day rate is not cutting it.

So... I am hoping that SOMEONE here can shed some light, and maybe help me figure out why this software won't work.

Thanks!

Chris

[] INSERT INTO photos (id,user,userid,cat,date,title,description,keyword
s,bigimage,width,height,filesize,medwidth,medheigh
t,medsize,approved,lastpost,watermarked,allowprint
,extra1,extra2,extra3,extra4,extra5,extra6) values(NULL,'Raconteur', 79, 509, 1048191297, 'barbouriLg', '', '', 'barbouriLg.jpg', 640, 480, 97407, , , , 1, 1048191297, 'no','','','','','','','') [/]

File image-inc.php line 540:

Find: $query = "INSERT INTO photosINSERT INTO photo...
values(NULL,'$username',....
change values(..) to

values(NULL,'$username', '$userid', '$thecat', '$julian', '$ititle', '$idesc', '$ikeywords', '$realname', '$imagewidth', '$imageheight', '$imagesize',
'$medwidth', '$medheight', '$medsize', '$moderate', '$julian', '$watermarked','$allowprint','$extra1','$extra2','$extra3','$extra4','$extra5','$extra6')";

have you looked at your photopost database with phpMyAdmin or something to verify the tables and such are there?

As for the path to mogrify, do tou have telnet or SSH access? You can easily verify the path yourself if you do by typing "locate mogrify" at the command prompt. A lot of times hosts will either install old versions of ImageMagick, or install it incorrectly, or just plain not know the real path of the executable.

Hi Goshik,

Are you just adding the NULL to the value list here?? Have you experienced this same problem? I did not see anything about this on the PPPro site...

Hi msula,

The DB tables are all good... not sure if I have telnet access to our host... have to find out.

Does anyone know if Mogrify is better or worse than GD1 or GD2??

If they are the same, then I am not going to bother because I just got it working with GD1.

GD1 sucks, GD2 is good, comparable with ImageMagick. The only drawback is unless the host manually edited GD2, there is no GIF support

I am also having problems with Photo Post.

Here is the error I am getting:

Warning: unlink() [function.unlink]: No such file or directory in /home/socapsn/public_html/photopost/image-inc.php on line 403

&

Error creating resized original! Error code: 15


I have uploaded the images via ftp into the correct folder and get to the last step, past the page were it shows the thumbnail and I come up with the above error.


Testing UNZIP at: /usr/bin/unzip.... OK, found the file!
Testing MOGRIFY at: /usr/bin/mogrify.... OK, found the file!


Any help would be appreciated,

Bobby

What graphics you using ImageMagick GD1 or GD2

[]Omegatron said:
What graphics you using ImageMagick GD1 or GD2 [/]
ImageMagick

Is this a new install?

I have seen others encounter this from Image Magick being configured incorrectly

Try saving this code below to a file and name it info.php and upload it to your server. Then run it and tell me what version GD is on your server.

<?php

// Show all information, defaults to INFO_ALL
phpinfo();

?>

[]Omegatron said:
....then run it and tell me what version GD is on your server. [/]
GD Version bundled (2.0 compatible)

Okay try changing the config file to GD2 which should be 1 and reuploading it. If you have GD2 you should really try using that instead of ImageMagick. Try uploading an image after that.

The section of code you want to edit in config file will be this

// GD2 support
// this will only work if you have GD1 or GD2 installed
// 0 - use mogrify; 1 - use GD2; 2- use GD1
$usegd = 1;

What version of IM do you have running? The format command is something on the more recent versions and the parameter is JPG, not JPEG. (Although JPEG can be used and is quoted in the example on imagemagick.org).

We had one host that also suggested using JPEG and we manually changed the command to force a JPEG into the command line and this fixed their problem. However, we have been unable to figure out WHY and for WHAT users.

We see some cases where the medium variable are NULL - and usually there is another error concerning the getfilesize() call. Most of the times I have seen this, there has been a permissions issue on the data directory.

Keep in mind, the SERVER has to have access to all these directories. unlink errors usually indicate that the server doesnt have permission to remove a file or the file was never able to be moved there in the first place.

Also helps to know what version of PHP you are using, what version of MYSQL and what version of IM.

GD2 is MUCH better than GD1. GD1 uses a resize and GD2 uses a resample; the quality of the thumbnails of GD2 is as good as IM.

I make probably 40-60 posts a day on PP forums; not sure why you are only getting one response a day.

n/m

Now dont I feel like the fool. Your thread is like 2 months old!

LOL
That's OK

Michael thats funny. Yeah BWilliams bumped it to the top.

In 3.3.1, I added some code when I found some documentation where getimagesize() failed on some types of JPGs. I'm hoping this solved that error. But when I first saw this thread, I was like WTF?!

Sorry for the confusion

In the future should I not bring a post to the top and just start a new one?

I am out of town and just now read the replies. I am still having problems though, but will try and upgrade to see if that takes care of it when I return home on Monday.

I have not upgraded a forum or anything that requires a lot of knowledge, is there detail instructions as to how I would go about upgrading photo post somewhere that I over looked?

I think if you want help with PhotoPost that you should go to the PhotoPost support pages. This is not a PP support forum.

[]extremebikini said:
I think if you want help with PhotoPost that you should go to the PhotoPost support pages. This is not a PP support forum. [/]
I have made a post over on the PP Support site. I just seen this thread and jumped in as there is a lot more traffic here than there it seems.

Thanks,

Bobby